dfa1fade4cd0d2243506d62e81854ec88531e362,portal-impl/src/com/liferay/portal/upgrade/v7_0_0/UpgradeRatings.java,UpgradeRatings,upgradeRatingsStats,#,139

Before Change


			PreparedStatement ps = con.prepareStatement(selectSQL);
			ResultSet rs = ps.executeQuery()) {

			DatabaseMetaData databaseMetaData = con.getMetaData();

			boolean supportsBatchUpdates =
				databaseMetaData.supportsBatchUpdates();

			try (PreparedStatement ps2 = con.prepareStatement(updateSQL)) {
				int count = 0;

				while (rs.next()) {
					ps2.setInt(1, rs.getInt("totalEntries"));
					ps2.setDouble(2, rs.getDouble("totalScore"));
					ps2.setDouble(3, rs.getDouble("averageScore"));
					ps2.setLong(4, rs.getLong("classNameId"));
					ps2.setLong(5, rs.getLong("classPK"));

					if (supportsBatchUpdates) {
						ps2.addBatch();

						if (count == PropsValues.HIBERNATE_JDBC_BATCH_SIZE) {
							ps2.executeBatch();

							count = 0;
						}
						else {
							count++;
						}
					}
					else {
						ps2.executeUpdate();
					}
				}

				if (supportsBatchUpdates && (count > 0)) {
					ps2.executeBatch();
				}
			}
		}

After Change


					ps2.setLong(4, rs.getLong("classNameId"));
					ps2.setLong(5, rs.getLong("classPK"));

					ps2.addBatch();
				}

				ps2.executeBatch();
			}
		}
	}